from openpyxl import load_workbook


class excel():
    def __init__(self,path,sheetname):
        self.path = load_workbook(path)
        self.sheetname = self.path[sheetname]

    def get_data(self):
        datalist=[]
        for line in self.sheetname:
            lists = []
            lists.append(line[0].value)
            lists.append(line[1].value)
            lists.append(line[3].value)
            lists.append(line[5].value)
            lists.append(line[8].value)
            lists.append(line[9].value)
            lists.append(line[10].value)
            lists.append(line[11].value)
            datalist.append(lists)
        return datalist

if __name__ == '__main__':
    path = r'/unit__001/unit_01/excel.xlsx'
    sheetname = 'Sheet1'
    dy = excel(path,sheetname)
    print(dy.get_data())
